create   EXTERNAL table jms_ods.tab_order_source_group_hi
(
  ID                         bigint  comment 'id',
  ORDER_SOURCE_GROUP_ID      bigint  comment '订单分类ID',
  ORDER_SOURCE_GROUP_NAME    string  comment '订单分类名称',
  ORDER_SOURCE_NAME          string  comment '订单来源名称',
  ORDER_SOURCE_CODE          string  comment '订单来源code',
  ORDER_SOURCE_GROUP_ID_CODE string  comment '订单来源分类id与订单来源code',
  UPdate_BY_NAME             string  comment '修改人名称',
  UPdate_TIME                date  comment '修改时间'
)
 PARTITIONED BY (
 dt string COMMENT '时间分区')
 ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1'
)
STORED AS
  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION '/dw/hive/jms_ods.db/external/tab_order_source_group_hi';